<!DOCTYPE html>
<html lang="en-US">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Format attributes | Luckysheet Document</title>
    <meta name="generator" content="VuePress 1.8.0">
    
    <meta name="description" content="Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.This site contains official configuration document, API, and tutorial.">
    <meta property="article:modified_time" content="2021-01-19T01:33:53.000Z">
    <meta property="og:title" content="Format attributes">
    <meta property="og:type" content="article">
    <meta property="og:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/cell.html">
    <meta name="twitter:title" content="Format attributes">
    <meta name="twitter:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/cell.html">
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:label1" content="Written by">
    
    <link rel="preload" href="/LuckysheetDocs/assets/css/0.styles.58462003.css" as="style"><link rel="preload" href="/LuckysheetDocs/assets/js/app.02d9598d.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/2.daa13025.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/14.61ea2478.js" as="script"><link rel="prefetch" href="/LuckysheetDocs/assets/js/10.866635ea.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/11.825eabba.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/12.980dcb91.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/13.119fa3a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/15.51a43d85.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/16.de626d16.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/17.e9ae302c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/18.46d5e5a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/19.6ab6bd88.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/20.a4dd0048.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/21.cf5034d8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/22.c45a4387.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/23.e08fd533.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/24.d1e4369b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/25.291afc50.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/26.e74f90a6.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/27.1142ecb7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/28.d6d28da0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/29.1ae5f953.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/3.c428902d.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/30.bf70d4f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/31.d87cf3af.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/32.a1b6f5f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/33.eded6080.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/4.b5e0f872.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/5.e526f9d4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/6.8106d72b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/7.c0fe87fd.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/8.abc5c19b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/9.2bf3882a.js">
    <link rel="stylesheet" href="/LuckysheetDocs/assets/css/0.styles.58462003.css">
  </head>
  <body>
    <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/LuckysheetDocs/" class="home-link router-link-active"><img src="/LuckysheetDocs/img/logo.png" alt="Luckysheet Document" class="logo"> <span class="site-name can-hide">Luckysheet Document</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" class="nav-link router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/cell.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/cell.html" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" class="nav-link router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/cell.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/cell.html" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav>  <ul class="sidebar-links"><li><a href="/LuckysheetDocs/guide/" aria-current="page" class="sidebar-link">Get started</a></li><li><a href="/LuckysheetDocs/guide/config.html" class="sidebar-link">Overall configuration</a></li><li><a href="/LuckysheetDocs/guide/sheet.html" class="sidebar-link">Sheet Configuration</a></li><li><a href="/LuckysheetDocs/guide/cell.html" aria-current="page" class="active sidebar-link">Format attributes</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/cell.html#cell-attributes-table" class="sidebar-link">Cell attributes table</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/cell.html#cell-format" class="sidebar-link"></a></li></ul></li><li><a href="/LuckysheetDocs/guide/operate.html" class="sidebar-link">Table Operation</a></li><li><a href="/LuckysheetDocs/guide/api.html" class="sidebar-link">API</a></li><li><a href="/LuckysheetDocs/guide/resource.html" class="sidebar-link">Tutorials and resources</a></li><li><a href="/LuckysheetDocs/guide/FAQ.html" class="sidebar-link">FAQ</a></li><li><a href="/LuckysheetDocs/guide/contribute.html" class="sidebar-link">Contribution guide</a></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="format-attributes"><a href="#format-attributes" class="header-anchor">#</a> Format attributes</h1> <h2 id="cell-attributes-table"><a href="#cell-attributes-table" class="header-anchor">#</a> Cell attributes table</h2> <table><tr><td>Attribute value</td> <td>Full name</td> <td><div style="width:100px;">Explanation</div></td> <td>Example value</td> <td>Aspose method or attribute</td></tr> <tr><td>ct</td> <td>celltype</td> <td>Cell value format: text, time, etc.</td> <td><a href="#cellStyle">Cell format</a></td> <td></td></tr> <tr><td>bg</td> <td>background</td> <td>background color</td> <td>#fff000</td> <td>setBackgroundColor</td></tr> <tr><td>ff</td> <td>fontfamily</td> <td>Font</td> <td>0 Times New Roman, 1 Arial, 2 Tahoma, 3 Verdana, 4 Microsoft Yahei, 5 Song, 6 ST Heiti, 7 ST Kaiti, 8 ST FangSong, 9 ST Song, 10 Chinese New Wei, 11 Chinese Xingkai, 12 Chinese Lishu</td> <td>Style.Font object's Name property.</td></tr> <tr><td>fc</td> <td>fontcolor</td> <td>font color</td> <td>#fff000</td> <td>Style.Font object's Color property</td></tr> <tr><td>bl</td> <td>bold</td> <td>Bold</td> <td>0 Regular, 1 Bold</td> <td>Style.Font object's IsBold property to true.</td></tr> <tr><td>it</td> <td>italic</td> <td>Italic</td> <td>0 Regular, 1 Italic</td> <td></td></tr> <tr><td>fs</td> <td>fontsize</td> <td>font size</td> <td>14</td> <td>Style.Font object's Size property.</td></tr> <tr><td>cl</td> <td>cancelline</td> <td>Cancelline</td> <td>0 Regular, 1 Cancelline</td> <td>Style.Font object's Underline property</td></tr> <tr><td>vt</td> <td>verticaltype</td> <td>Vertical alignment</td> <td>0 middle, 1 up, 2 down</td> <td>setVerticalAlignment</td></tr> <tr><td>ht</td> <td>horizontaltype</td> <td>Horizontal alignment</td> <td>0 center, 1 left, 2 right</td> <td>setHorizontalAlignment</td></tr> <tr><td>mc</td> <td>mergecell</td> <td>Merge Cells</td> <td>{rs: 10, cs:5} indicates that the cells from this cell to 10 rows and 5 columns are merged.</td> <td>Merge</td></tr> <tr><td>tr</td> <td>textrotate</td> <td>Text rotation</td> <td>0:  0、1:  45 、2: -45、3 Vertical text、4:  90 、5: -90</td> <td>setRotationAngle</td></tr> <tr><td>tb</td> <td>textbeak</td> <td>Text wrap</td> <td>0 truncation, 1 overflow, 2 word wrap</td> <td>2: setTextWrapped <br> 0和1: IsTextWrapped = true</td></tr> <tr><td>v</td> <td>value</td> <td>Original value</td> <td></td> <td></td></tr> <tr><td>m</td> <td>monitor</td> <td>Display value</td> <td></td> <td></td></tr> <tr><td>f</td> <td>function</td> <td>formula</td> <td></td> <td>setFormula <br> setArrayFormula <br> workbook.calculateFormula();</td></tr></table> <p>The following is the storage of 3 cells:</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
        <span class="token property">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">11</span><span class="token punctuation">,</span>
        <span class="token property">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;f&quot;</span><span class="token operator">:</span> <span class="token string">&quot;=MAX(A7:A9)&quot;</span><span class="token punctuation">,</span>
            <span class="token property">&quot;ct&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;fa&quot;</span><span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;t&quot;</span><span class="token operator">:</span> <span class="token string">&quot;n&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;v&quot;</span><span class="token operator">:</span> <span class="token number">100</span><span class="token punctuation">,</span>
            <span class="token property">&quot;m&quot;</span><span class="token operator">:</span> <span class="token string">&quot;100&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;v&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
            <span class="token property">&quot;f&quot;</span><span class="token operator">:</span> <span class="token string">&quot;=SUM(A2)&quot;</span><span class="token punctuation">,</span>
            <span class="token property">&quot;bg&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#fff000&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
        <span class="token property">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">11</span><span class="token punctuation">,</span>
        <span class="token property">&quot;v&quot;</span><span class="token operator">:</span> <span class="token string">&quot;值2&quot;</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div><h2 id="cell-format"><a href="#cell-format" class="header-anchor">#</a> <div id="cellStyle">Cell format</div></h2> <p>Reference<a href="https://docs.aspose.com/display/cellsnet/List+of+Supported+Number+Formats#ListofSupportedNumberFormats-Aspose.Cells" target="_blank" rel="noopener noreferrer">Aspose.Cells<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></p> <p>The format is set to:</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    <span class="token property">&quot;ct&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token property">&quot;fa&quot;</span><span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;t&quot;</span><span class="token operator">:</span> <span class="token string">&quot;g&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token property">&quot;m&quot;</span><span class="token operator">:</span> <span class="token string">&quot;2424&quot;</span><span class="token punctuation">,</span>
    <span class="token property">&quot;v&quot;</span><span class="token operator">:</span> <span class="token number">2424</span>
<span class="token punctuation">}</span>
</code></pre></div><table><thead><tr><th>Parameter</th> <th>Explanation</th> <th>Value</th></tr></thead> <tbody><tr><td>fa</td> <td>Format definition string</td> <td>such as &quot;General&quot;</td></tr> <tr><td>t</td> <td>Type</td> <td>Such as &quot;g&quot;</td></tr></tbody></table> <p>The available settings are as follows:</p> <table><thead><tr><th>Format</th> <th>ct.fa</th> <th>ct.t</th> <th>Example of m value</th> <th>Remarks</th></tr></thead> <tbody><tr><td>Automatic</td> <td>General</td> <td>g</td> <td>Luckysheet</td> <td>Automatic format, which is also the default format; When the cell content is a number, the value of <code>m</code> is <code>'n'</code></td></tr> <tr><td>Plain text</td> <td>@</td> <td>s</td> <td>Luckysheet</td> <td></td></tr> <tr><td><br><br><br><strong>Number Format</strong></td> <td></td> <td></td> <td></td> <td></td></tr> <tr><td>Integer</td> <td>0</td> <td>n</td> <td>1235</td> <td>0 decimal places</td></tr> <tr><td>One decimal place of the number</td> <td>0.0</td> <td>n</td> <td>1234.6</td> <td>The number of 0 after the dot represents the number of decimal places. If the original number is large, the number of digits will be rounded to the nearest hour</td></tr> <tr><td>Two decimal places</td> <td>0.00</td> <td>n</td> <td>1234.56</td> <td></td></tr> <tr><td>Percentage integer</td> <td>0%</td> <td>n</td> <td>123456%</td> <td>The usage of #0% is also supported</td></tr> <tr><td>Percentage</td> <td>0.00%</td> <td>n</td> <td>123456.00%</td> <td>The usage of #0.00% is also supported. The number of 0 after the dot represents the number of decimal places</td></tr> <tr><td>Scientific Notation</td> <td>0.00E+00</td> <td>n</td> <td>1.23E+03</td> <td></td></tr> <tr><td>Scientific Notation</td> <td>##0.0E+0</td> <td>n</td> <td>1.2E+3</td> <td></td></tr> <tr><td>Fractions</td> <td># ?/?</td> <td>n</td> <td>1234 5/9</td> <td></td></tr> <tr><td>Score</td> <td># ??/??</td> <td>n</td> <td>1234 14/25</td> <td></td></tr> <tr><td>Ten thousand</td> <td>w</td> <td>n</td> <td>123 thousand and 456</td> <td></td></tr> <tr><td>Ten thousand two decimal places</td> <td>w0.00</td> <td>n</td> <td>123 thousand and 3456.00</td> <td></td></tr> <tr><td>Accounting</td> <td>¥(0.00)</td> <td>n</td> <td></td> <td></td></tr> <tr><td>More number formats</td> <td>#,##0</td> <td>n</td> <td>1,235</td> <td></td></tr> <tr><td>More number formats</td> <td>#,##0.00</td> <td>n</td> <td>1,234.56</td> <td></td></tr> <tr><td>More number formats</td> <td><code>#,##0_);(#,##0)</code></td> <td>n</td> <td>1,235</td> <td></td></tr> <tr><td>More number formats</td> <td><code>#,##0_);[Red](#,##0)</code></td> <td>n</td> <td>1,235</td> <td></td></tr> <tr><td>More number formats</td> <td><code>#,##0.00_);(#,##0.00)</code></td> <td>n</td> <td>1,234.56</td> <td></td></tr> <tr><td>More number formats</td> <td><code>#,##0.00_);[Red](#,##0.00)</code></td> <td>n</td> <td>1,234.56</td> <td></td></tr> <tr><td>More number formats</td> <td>$#,##0_);($#,##0)</td> <td>n</td> <td>$1,235</td> <td></td></tr> <tr><td>More number formats</td> <td><code>$#,##0_);[Red]($#,##0)</code></td> <td>n</td> <td>$1,235</td> <td></td></tr> <tr><td>More number formats</td> <td>$#,##0.00_);($#,##0.00)</td> <td>n</td> <td>$1,234.56</td> <td></td></tr> <tr><td>More number formats</td> <td><code>$#,##0.00_);[Red]($#,##0.00)</code></td> <td>n</td> <td>$1,234.56</td> <td></td></tr> <tr><td>More number formats</td> <td><em>($* #,##0</em>);<em>(...($* &quot;-&quot;</em>);<em>(@</em>)</td> <td>n</td> <td>$ 1,235</td> <td></td></tr> <tr><td>More number formats</td> <td><em>(* #,##0</em>);<em>(*...</em>(* &quot;-&quot;<em>);</em>(@_)</td> <td>n</td> <td>1,235</td> <td></td></tr> <tr><td>More number formats</td> <td><em>($* #,##0.00</em>);<em>(...($* &quot;-&quot;</em>);<em>(@</em>)</td> <td>n</td> <td>$ 1,234.56</td> <td></td></tr> <tr><td>More number formats</td> <td><em>(* #,##0.00</em>);...* &quot;-&quot;??<em>);</em>(@_)</td> <td>n</td> <td>1,234.56</td> <td></td></tr> <tr><td><br><br><br><strong>Time and Date Format</strong></td> <td></td> <td></td> <td></td> <td></td></tr> <tr><td>Time</td> <td>hh:mm AM/PM</td> <td>d</td> <td>10:23 AM</td> <td></td></tr> <tr><td>Time 24H</td> <td>hh:mm</td> <td>d</td> <td>10:23</td> <td></td></tr> <tr><td>Date Time</td> <td>yyyy-MM-dd hh:mm AM/PM</td> <td>d</td> <td>2020-07-29 10:23 AM</td> <td></td></tr> <tr><td>Date Time 24H</td> <td>yyyy-MM-dd hh:mm</td> <td>d</td> <td>2020-07-29 10:23</td> <td></td></tr> <tr><td>Date</td> <td>yyyy-MM-dd</td> <td>d</td> <td>1930-08-05</td> <td></td></tr> <tr><td>Date</td> <td>yyyy/MM/dd</td> <td>d</td> <td>1930/8/5</td> <td></td></tr> <tr><td>Date</td> <td>yyyy &quot;year&quot; M&quot; month &quot;d&quot; day&quot;</td> <td>d</td> <td>August 5, 1930</td> <td></td></tr> <tr><td>Date</td> <td>MM-dd</td> <td>d</td> <td>08-05</td> <td></td></tr> <tr><td>Date</td> <td>M-d</td> <td>d</td> <td>8-5</td> <td></td></tr> <tr><td>Date</td> <td>M&quot;Month&quot;d&quot;Day&quot;</td> <td>d</td> <td>August 5th</td> <td></td></tr> <tr><td>Date</td> <td>h:mm:ss</td> <td>d</td> <td>13:30:30</td> <td></td></tr> <tr><td>Date</td> <td>h:mm</td> <td>d</td> <td>13:30</td> <td></td></tr> <tr><td>Date</td> <td>AM/PM hh:mm</td> <td>d</td> <td>01:30 PM</td> <td></td></tr> <tr><td>Date</td> <td>AM/PM h:mm</td> <td>d</td> <td>1:30 PM</td> <td></td></tr> <tr><td>Date</td> <td>AM/PM h:mm:ss</td> <td>d</td> <td>1:30:30 PM</td> <td></td></tr> <tr><td>Date</td> <td>MM-dd AM/PM hh:mm</td> <td>d</td> <td>Next 08-05 01:30 PM</td> <td></td></tr> <tr><td><br><br><br><strong>Currency Format</strong></td> <td></td> <td></td> <td></td> <td></td></tr> <tr><td>Currency: RMB</td> <td>&quot;¥&quot; 0.00</td> <td>n</td> <td>¥ 123.00</td> <td>Also supports ¥ #.00 or ¥0.00</td></tr> <tr><td>Currency: US Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Euro</td> <td>&quot;€&quot; 0.00</td> <td>n</td> <td>€ 123.00</td> <td></td></tr> <tr><td>Currency: British Pound</td> <td>&quot;￡&quot; 0.00</td> <td>n</td> <td>￡ 123.00</td> <td></td></tr> <tr><td>Currency: Hong Kong Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Japanese Yen</td> <td>&quot;￥&quot; 0.00</td> <td>n</td> <td>￥123.00</td> <td></td></tr> <tr><td>Currency: Albanian Lek</td> <td>&quot;Lek&quot; 0.00</td> <td>n</td> <td>Lek 123.00</td> <td></td></tr> <tr><td>Currency: Algerian Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Afghani</td> <td>&quot;Af&quot; 0.00</td> <td>n</td> <td>Af 123.00</td> <td></td></tr> <tr><td>Currency: Argentine Peso</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: United Arab Emirates Dirham</td> <td>&quot;dh&quot; 0.00</td> <td>n</td> <td>dh 123.00</td> <td></td></tr> <tr><td>Currency: Aruban Florin</td> <td>&quot;Afl&quot; 0.00</td> <td>n</td> <td>Afl 123.00</td> <td></td></tr> <tr><td>Currency: Omani Rial</td> <td>&quot;Rial&quot; 0.00</td> <td>n</td> <td>Rial 123.00</td> <td></td></tr> <tr><td>Currency: Azerbaijani Manat</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Egyptian Pound</td> <td>&quot;￡&quot; 0.00</td> <td>n</td> <td>￡ 123.00</td> <td></td></tr> <tr><td>Currency: Ethiopian Birr</td> <td>&quot;Birr&quot; 0.00</td> <td>n</td> <td>Birr 123.00</td> <td></td></tr> <tr><td>Currency: Angolan Kwanza</td> <td>&quot;Kz&quot; 0.00</td> <td>n</td> <td>Kz 123.00</td> <td></td></tr> <tr><td>Currency: Australian Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Macau Patacas</td> <td>&quot;MOP&quot; 0.00</td> <td>n</td> <td>MOP 123.00</td> <td></td></tr> <tr><td>Currency: Barbadian Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Papua New Guinea Kina</td> <td>&quot;PGK&quot; 0.00</td> <td>n</td> <td>PGK 123.00</td> <td></td></tr> <tr><td>Currency: Bahamian Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Pakistani Rupee</td> <td>&quot;Rs&quot; 0.00</td> <td>n</td> <td>Rs 123.00</td> <td></td></tr> <tr><td>Currency: Paraguayan Guarani</td> <td>&quot;Gs&quot; 0.00</td> <td>n</td> <td>Gs 123.00</td> <td></td></tr> <tr><td>Currency: Bahraini Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Panamanian Balboa</td> <td>&quot;B/&quot; 0.00</td> <td>n</td> <td>B/ 123.00</td> <td></td></tr> <tr><td>Currency: Brazilian Riyal</td> <td>&quot;R$&quot; 0.00</td> <td>n</td> <td>R$ 123.00</td> <td></td></tr> <tr><td>Currency: Belarusian ruble</td> <td>&quot;р&quot; 0.00</td> <td>n</td> <td>р 123.00</td> <td></td></tr> <tr><td>Currency: Bermudian Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Bulgarian Lev</td> <td>&quot;lev&quot; 0.00</td> <td>n</td> <td>lev 123.00</td> <td></td></tr> <tr><td>Currency: Iceland Krona</td> <td>&quot;kr&quot; 0.00</td> <td>n</td> <td>kr 123.00</td> <td></td></tr> <tr><td>Currency: Bosnia and Herzegovina convertible mark</td> <td>&quot;KM&quot; 0.00</td> <td>n</td> <td>KM 123.00</td> <td></td></tr> <tr><td>Currency: Polish Zloty</td> <td>&quot;z?&quot; 0.00</td> <td>n</td> <td>z? 123.00</td> <td></td></tr> <tr><td>Currency: Boliviano</td> <td>&quot;Bs&quot; 0.00</td> <td>n</td> <td>Bs 123.00</td> <td></td></tr> <tr><td>Currency: Belize Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Botswana Pula</td> <td>&quot;P&quot; 0.00</td> <td>n</td> <td>P 123.00</td> <td></td></tr> <tr><td>Currency: Bhutan Nusam</td> <td>&quot;Nu&quot; 0.00</td> <td>n</td> <td>Nu 123.00</td> <td></td></tr> <tr><td>Currency: Burundian Franc</td> <td>&quot;FBu&quot; 0.00</td> <td>n</td> <td>FBu 123.00</td> <td></td></tr> <tr><td>Currency: North Korean Won</td> <td>&quot;?KP&quot; 0.00</td> <td>n</td> <td>?KP 123.00</td> <td></td></tr> <tr><td>Currency: Danish Krone</td> <td>&quot;kr&quot; 0.00</td> <td>n</td> <td>kr 123.00</td> <td></td></tr> <tr><td>Currency: East Caribbean Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Dominican Peso</td> <td>&quot;RD$&quot; 0.00</td> <td>n</td> <td>RD$ 123.00</td> <td></td></tr> <tr><td>Currency: Russian ruble</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Eritrean Nakfa</td> <td>&quot;Nfk&quot; 0.00</td> <td>n</td> <td>Nfk 123.00</td> <td></td></tr> <tr><td>Currency: CFA franc</td> <td>&quot;CFA&quot; 0.00</td> <td>n</td> <td>CFA 123.00</td> <td></td></tr> <tr><td>Currency: Philippine Peso</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Fijian Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Cape Verde Escudo</td> <td>&quot;CVE&quot; 0.00</td> <td>n</td> <td>CVE 123.00</td> <td></td></tr> <tr><td>Currency: Falkland Islands Pound</td> <td>&quot;￡&quot; 0.00</td> <td>n</td> <td>￡ 123.00</td> <td></td></tr> <tr><td>Currency: Gambia Dalasi</td> <td>&quot;GMD&quot; 0.00</td> <td>n</td> <td>GMD 123.00</td> <td></td></tr> <tr><td>Currency: Congolese Franc</td> <td>&quot;FrCD&quot; 0.00</td> <td>n</td> <td>FrCD 123.00</td> <td></td></tr> <tr><td>Currency: Colombian Peso</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Costa Rican Colon</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Cuban Peso</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Cuban Convertible Peso</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Guyana Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Kazakhstan tenge</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Haitian Gourde</td> <td>&quot;HTG&quot; 0.00</td> <td>n</td> <td>HTG 123.00</td> <td></td></tr> <tr><td>Currency: Korean Won</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Netherlands Antilles Guild</td> <td>&quot;NAf.&quot; 0.00</td> <td>n</td> <td>NAf. 123.00</td> <td></td></tr> <tr><td>Currency: Honduras Lalempira</td> <td>&quot;L&quot; 0.00</td> <td>n</td> <td>L 123.00</td> <td></td></tr> <tr><td>Currency: Djiboutian Franc</td> <td>&quot;Fdj&quot; 0.00</td> <td>n</td> <td>Fdj 123.00</td> <td></td></tr> <tr><td>Currency: Kyrgyzstan Som</td> <td>&quot;KGS&quot; 0.00</td> <td>n</td> <td>KGS 123.00</td> <td></td></tr> <tr><td>Currency: Guinean Franc</td> <td>&quot;FG&quot; 0.00</td> <td>n</td> <td>FG 123.00</td> <td></td></tr> <tr><td>Currency: Canadian Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Ghanaian Cedi</td> <td>&quot;GHS&quot; 0.00</td> <td>n</td> <td>GHS 123.00</td> <td></td></tr> <tr><td>Currency: Cambodian Riel</td> <td>&quot;Riel&quot; 0.00</td> <td>n</td> <td>Riel 123.00</td> <td></td></tr> <tr><td>Currency: Czech Koruna</td> <td>&quot;K?&quot; 0.00</td> <td>n</td> <td>K? 123.00</td> <td></td></tr> <tr><td>Currency: Zimbabwe dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Qatari Rial</td> <td>&quot;Rial&quot; 0.00</td> <td>n</td> <td>Rial 123.00</td> <td></td></tr> <tr><td>Currency: Cayman Islands Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Comorian Franc</td> <td>&quot;CF&quot; 0.00</td> <td>n</td> <td>CF 123.00</td> <td></td></tr> <tr><td>Currency: Kuwaiti Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Croatian Kuna</td> <td>&quot;kn&quot; 0.00</td> <td>n</td> <td>kn 123.00</td> <td></td></tr> <tr><td>Currency: Kenyan Shilling</td> <td>&quot;Ksh&quot; 0.00</td> <td>n</td> <td>Ksh 123.00</td> <td></td></tr> <tr><td>Currency: Lesotho Loti</td> <td>&quot;LSL&quot; 0.00</td> <td>n</td> <td>LSL 123.00</td> <td></td></tr> <tr><td>Currency: Lao Kip</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Lebanese Pound</td> <td>&quot;L￡&quot; 0.00</td> <td>n</td> <td>L￡ 123.00</td> <td></td></tr> <tr><td>Currency: Lithuanian Litas</td> <td>&quot;Lt&quot; 0.00</td> <td>n</td> <td>Lt 123.00</td> <td></td></tr> <tr><td>Currency: Libyan Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Libyan Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Rwandan franc</td> <td>&quot;RF&quot; 0.00</td> <td>n</td> <td>RF 123.00</td> <td></td></tr> <tr><td>Currency: Romanian Lei</td> <td>&quot;RON&quot; 0.00</td> <td>n</td> <td>RON 123.00</td> <td></td></tr> <tr><td>Currency: Madagascar Ariary</td> <td>&quot;Ar&quot; 0.00</td> <td>n</td> <td>Ar 123.00</td> <td></td></tr> <tr><td>Currency: Maldivian Rufiyaa</td> <td>&quot;Rf&quot; 0.00</td> <td>n</td> <td>Rf 123.00</td> <td></td></tr> <tr><td>Currency: Malawian Kwacha</td> <td>&quot;MWK&quot; 0.00</td> <td>n</td> <td>MWK 123.00</td> <td></td></tr> <tr><td>Currency: Malaysian Ringgit</td> <td>&quot;RM&quot; 0.00</td> <td>n</td> <td>RM 123.00</td> <td></td></tr> <tr><td>Currency: Macedonian Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Mauritian Rupee</td> <td>&quot;MURs&quot; 0.00</td> <td>n</td> <td>MURs 123.00</td> <td></td></tr> <tr><td>Currency: Mauritania Ouguiya</td> <td>&quot;MRO&quot; 0.00</td> <td>n</td> <td>MRO 123.00</td> <td></td></tr> <tr><td>Currency: Mongolian Tugrik</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Bangladeshi Taka</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Peruvian New Sol</td> <td>&quot;S/&quot; 0.00</td> <td>n</td> <td>S/ 123.00</td> <td></td></tr> <tr><td>Currency: Myanmar Kyat</td> <td>&quot;K&quot; 0.00</td> <td>n</td> <td>K 123.00</td> <td></td></tr> <tr><td>Currency: Moldovan Lei</td> <td>&quot;MDL&quot; 0.00</td> <td>n</td> <td>MDL 123.00</td> <td></td></tr> <tr><td>Currency: Moroccan Dirham</td> <td>&quot;dh&quot; 0.00</td> <td>n</td> <td>dh 123.00</td> <td></td></tr> <tr><td>Currency: Mozambique Metical</td> <td>&quot;MTn&quot; 0.00</td> <td>n</td> <td>MTn 123.00</td> <td></td></tr> <tr><td>Currency: Mexican Peso</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Namibian Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: South African Rand</td> <td>&quot;R&quot; 0.00</td> <td>n</td> <td>R 123.00</td> <td></td></tr> <tr><td>Currency: South Sudanese Pound</td> <td>&quot;￡&quot; 0.00</td> <td>n</td> <td>￡ 123.00</td> <td></td></tr> <tr><td>Currency: Nicaragua Cordoba</td> <td>&quot;C$&quot; 0.00</td> <td>n</td> <td>C$ 123.00</td> <td></td></tr> <tr><td>Currency: Nepalese Rupee</td> <td>&quot;Rs&quot; 0.00</td> <td>n</td> <td>Rs 123.00</td> <td></td></tr> <tr><td>Currency: Nigerian Naira</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Norwegian Krone</td> <td>&quot;kr&quot; 0.00</td> <td>n</td> <td>kr 123.00</td> <td></td></tr> <tr><td>Currency: Georgia Lari</td> <td>&quot;GEL&quot; 0.00</td> <td>n</td> <td>GEL 123.00</td> <td></td></tr> <tr><td>Currency: RMB (Offshore)</td> <td>&quot;￥&quot; 0.00</td> <td>n</td> <td>￥123.00</td> <td></td></tr> <tr><td>Currency: Swedish Krona</td> <td>&quot;kr&quot; 0.00</td> <td>n</td> <td>kr 123.00</td> <td></td></tr> <tr><td>Currency: Swiss Franc</td> <td>&quot;CHF&quot; 0.00</td> <td>n</td> <td>CHF 123.00</td> <td></td></tr> <tr><td>Currency: Serbian Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Sierra Leone Leone</td> <td>&quot;SLL&quot; 0.00</td> <td>n</td> <td>SLL 123.00</td> <td></td></tr> <tr><td>Currency: Seychelles Rupee</td> <td>&quot;SCR&quot; 0.00</td> <td>n</td> <td>SCR 123.00</td> <td></td></tr> <tr><td>Currency: Saudi Riyal</td> <td>&quot;Rial&quot; 0.00</td> <td>n</td> <td>Rial 123.00</td> <td></td></tr> <tr><td>Currency: Sao Tome Dobra</td> <td>&quot;Db&quot; 0.00</td> <td>n</td> <td>Db 123.00</td> <td></td></tr> <tr><td>Currency: St. Helena Pound</td> <td>&quot;￡&quot; 0.00</td> <td>n</td> <td>￡ 123.00</td> <td></td></tr> <tr><td>Currency: Sri Lankan Rupee</td> <td>&quot;Rs&quot; 0.00</td> <td>n</td> <td>Rs 123.00</td> <td></td></tr> <tr><td>Currency: Swaziland Lilangeni</td> <td>&quot;SZL&quot; 0.00</td> <td>n</td> <td>SZL 123.00</td> <td></td></tr> <tr><td>Currency: Sudanese Pound</td> <td>&quot;SDG&quot; 0.00</td> <td>n</td> <td>SDG 123.00</td> <td></td></tr> <tr><td>Currency: Surinamese Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Solomon Islands Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Somali Shilling</td> <td>&quot;SOS&quot; 0.00</td> <td>n</td> <td>SOS 123.00</td> <td></td></tr> <tr><td>Currency: Tajikistani Somoni</td> <td>&quot;Som&quot; 0.00</td> <td>n</td> <td>Som 123.00</td> <td></td></tr> <tr><td>Currency: Pacific Franc</td> <td>&quot;FCFP&quot; 0.00</td> <td>n</td> <td>FCFP 123.00</td> <td></td></tr> <tr><td>Currency: Thai Baht</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Tanzanian Shilling</td> <td>&quot;TSh&quot; 0.00</td> <td>n</td> <td>TSh 123.00</td> <td></td></tr> <tr><td>Currency: Tongan Paanga</td> <td>&quot;T$&quot; 0.00</td> <td>n</td> <td>T$ 123.00</td> <td></td></tr> <tr><td>Currency: Trinidad and Tobago Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Tunisian Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Turkish Lira</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Vanuatu Vatu</td> <td>&quot;VUV&quot; 0.00</td> <td>n</td> <td>VUV 123.00</td> <td></td></tr> <tr><td>Currency: Guatemalan Quetzal</td> <td>&quot;Q&quot; 0.00</td> <td>n</td> <td>Q 123.00</td> <td></td></tr> <tr><td>Currency: Venezuelan Bolivar</td> <td>&quot;Bs&quot; 0.00</td> <td>n</td> <td>Bs 123.00</td> <td></td></tr> <tr><td>Currency: Brunei Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Ugandan Shilling</td> <td>&quot;UGX&quot; 0.00</td> <td>n</td> <td>UGX 123.00</td> <td></td></tr> <tr><td>Currency: Ukrainian Hryvnia</td> <td>&quot;грн.&quot; 0.00</td> <td>n</td> <td>грн. 123.00</td> <td></td></tr> <tr><td>Currency: Uruguayan Peso</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Uzbekistani Sum</td> <td>&quot;so?m&quot; 0.00</td> <td>n</td> <td>so?m 123.00</td> <td></td></tr> <tr><td>Currency: Western Samoa Tala</td> <td>&quot;WST&quot; 0.00</td> <td>n</td> <td>WST 123.00</td> <td></td></tr> <tr><td>Currency: Singapore Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: New Taiwan Dollar</td> <td>&quot;NT$&quot; 0.00</td> <td>n</td> <td>NT$ 123.00</td> <td></td></tr> <tr><td>Currency: New Zealand Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Hungarian Forint</td> <td>&quot;Ft&quot; 0.00</td> <td>n</td> <td>Ft 123.00</td> <td></td></tr> <tr><td>Currency: Syrian Pound</td> <td>&quot;￡&quot; 0.00</td> <td>n</td> <td>￡ 123.00</td> <td></td></tr> <tr><td>Currency: Jamaican Dollar</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: Armenian Dram</td> <td>&quot;Dram&quot; 0.00</td> <td>n</td> <td>Dram 123.00</td> <td></td></tr> <tr><td>Currency: Yemeni Rial</td> <td>&quot;Rial&quot; 0.00</td> <td>n</td> <td>Rial 123.00</td> <td></td></tr> <tr><td>Currency: Iraqi Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Iranian Rial</td> <td>&quot;Rial&quot; 0.00</td> <td>n</td> <td>Rial 123.00</td> <td></td></tr> <tr><td>Currency: Israeli New Shekel</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Indian Rupee</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Indonesian Rupiah</td> <td>&quot;Rp&quot; 0.00</td> <td>n</td> <td>Rp 123.00</td> <td></td></tr> <tr><td>Currency: Jordanian Dinar</td> <td>&quot;din&quot; 0.00</td> <td>n</td> <td>din 123.00</td> <td></td></tr> <tr><td>Currency: Vietnamese Dong</td> <td>&quot;?&quot; 0.00</td> <td>n</td> <td>? 123.00</td> <td></td></tr> <tr><td>Currency: Zambian Kwacha</td> <td>&quot;ZMW&quot; 0.00</td> <td>n</td> <td>ZMW 123.00</td> <td></td></tr> <tr><td>Currency: Gibraltar Pound</td> <td>&quot;￡&quot; 0.00</td> <td>n</td> <td>￡ 123.00</td> <td></td></tr> <tr><td>Currency: Chilean Peso</td> <td>&quot;$&quot; 0.00</td> <td>n</td> <td>$ 123.00</td> <td></td></tr> <tr><td>Currency: China-Africa Financial Cooperation Franc</td> <td>&quot;FCFA&quot; 0.00</td> <td>n</td> <td>FCFA 123.00</td> <td></td></tr></tbody></table> <p>Notice: Import/export only considers the data style that the user sees. For example, the way to process the date format in excel is to convert the date into a number: 42736 represents 2017-1-1.</p></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/mengshukeji/Luckysheet/edit/master/docs/guide/cell.md" target="_blank" rel="noopener noreferrer">Edit this page on GitHub</a> <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></div> <div class="last-updated"><span class="prefix">Last Updated:</span> <span class="time">1/19/2021, 1:33:53 AM</span></div></footer> <div class="page-nav"><p class="inner"><span class="prev">
      ←
      <a href="/LuckysheetDocs/guide/sheet.html" class="prev">
        Sheet Configuration
      </a></span> <span class="next"><a href="/LuckysheetDocs/guide/operate.html">
        Table Operation
      </a>
      →
    </span></p></div> </main></div><div class="global-ui"></div></div>
    <script src="/LuckysheetDocs/assets/js/app.02d9598d.js" defer></script><script src="/LuckysheetDocs/assets/js/2.daa13025.js" defer></script><script src="/LuckysheetDocs/assets/js/14.61ea2478.js" defer></script>
  </body>
</html>
